How the Transactional Based Management Reports Generate Information

The transactional-based management reports look similar to existing period based management reports. The difference is in the way that the figures are calculated.

The existing versions use a monthly range to generate reports. For example, when running the existing profit and loss report, if you choose to run for the month range 4 to 7, the following figures are obtained:

$image\bullet.gif$ The current period contains totals from months 4 to 7.

$image\bullet.gif$ The year-to-date figure contains the totals up to month 7.

If you choose to run the existing balance sheet report for the month range 4 to 7 the following figures are obtained:

$image\bullet.gif$ The current period contains totals from months 4 to 7.

$image\bullet.gif$ The year-to-date figures contain the totals up to month 7 plus the brought forward figures.

$image\bullet.gif$ The profit and loss summary shows the total from the profit and loss report. This does not include any brought forward figures.

$image\bullet.gif$ The Previous Year Adjustment shows the brought forward figures.

The new transactional-based reports can be built for any date range. The figures are generated from the audit trail. The reports still need to group transactions into the following areas:

Brought Forward Figures

Current Period Figures

Year To Date Figures.

There are two ways of obtaining these figures:

1. You can use the date. The system uses the start of the financial year to determine if an item is brought forward.

2. Alternatively, you can use the transaction number. By entering the first transaction number of the financial year, the system can determine if an item is brought forward.

If you want to use the date to determine your figures, you must set the following criteria options when running your report:

1. Deselect the Group by Tran Number check box.

2. Enter the date range you require in the Transaction Dates From and To text boxes.

If you want to use the transaction number to determine your figures, you must set the following criteria options when running your report:

1. Select the Group by Tran Number check box.

2. Enter your first transaction number of the current financial year in the First Transaction of the Year text box. Any transaction numbers lower than this value are treated as brought forward figures.

3. Enter the transaction numbers for the current range in the Transaction Number From and To text boxes. From the values you enter here, the current period and year-to-date figures can be generated.

Note: If you have selected the Group by Tran Number check box, any date ranges you enter have no effect on the figures that are generated for your report. Only the transaction numbers determine the figures that are generated.